Copyright: ® Israel Kehaty 1994. All Rights Resereved.


©Copyright 1995 by Israel Kehaty. All Rights Reserved.

©Copyright 1995 by K.I.T.A.L. Software. All Rights Reserved.

FunctionMagic

Welcome

Legal Matters

ASP and Shareware

ASP Ombudsman Statement

Note for Shareware Distributors

Registration

Installation

Starting the Main Program

Using an Individual Function Without the Main Program


Welcome

FunctionMagic for Lotus 1-2-3 versions 4.x and 5.x for Windows 3.1 is a new and improved interface for Lotus functions. It is a tool that allows the Lotus user to enter and apply functions syntax free on a cell, a row or a column of data. Using dialog boxes, radio buttons, check buttons, command buttons and edit boxes, the user defines the function, enters data, selects options and selects data from the worksheet.


Legal Matters

©Copyright 1995 by Israel Kehaty. All Rights Reserved.

©Copyright 1995 by K.I.T.A.L. Software. All Rights Reserved.

All Rights Reserved. Printed in the United States of America and ISRAEL. No part of FunctionMagic may be used or reproduced in any form or by any means, or stored as a database or retrieval system, without the prior written permission of Israel Kehaty and K.I.T.A.L. Software, except in the case of brief quotation embodied in critical articles and reviews. Making copies of any part of FunctionMagic for any purpose other than your own personal use is a violation of United States and ISRAEL copyright laws and the international treaties.

FunctionMagic  AND THE ACCOMPANYING SOFTWARE IS WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, RESPECTING THE CONTENTS OF FunctionMagic AND THE ACCOMPANYING SOFTWARE, INCLUDING BUT NOT LIMITED TO IMPLIED WARRANTIES FOR THE SOFTWARE'S QUALITY, PERFORMANCE, MERCHANABILITY, OR FITNESS FOR ANY PARTICULAR PURPOSE. NEITHER ISRAEL KEHATY NOR K.I.T.A.L. SOFTWARE NOR ITS DEALERS OR DISTRIBUTORS SHALL BE LIABLE TO THE PURCHASER OR ANY OTHER PERSON OR ENTITY WITH RESPECT TO ANY LIABILITY, LOSS, OR DAMAGE CAUSED OR ALLEGED TO BE CAUSED DIRECTLY OR INDIRECTLY BY FunctionMagic AND/OR ITS ACCOMPANYING SOFTWARE.

If you purchased FunctionMagic you are NOT ALLOWED to distribute any part of it or use it in commercial applications that you develop and sell. The macros listed in FunctionMagic are commercial macros copyrighted by K.I.T.A.L Software.

You MUST treat this software the same way you treat a paper bound book. You can use it only on ONE CPU and on ONE VIEWING MACHINE at the same time. Therefore you cannot install it on ANY KIND of a network without purchasing a site license and you cannot install it on more than one personal computer.

Trademark Acknowledgment:

Lotus and 1-2-3 are registered trademarks of Lotus Development Corporation.

Windows and Help Compiler are registered trademarks of Microsoft Corporation.


ASP and Shareware


ASP Ombudsman Statement

This program is produced by a member of the Association of Shareware Professionals (ASP). ASP wants to make sure that the shareware principle works for you. If you are unable to resolve a shareware-related problem with an ASP member by contacting the member directly, ASP may be able to help. The ASP Ombudsman can help you resolve a dispute or problem with an ASP member, but does not provide technical support for members' products.

Please write to the ASP Ombudsman at:

          ASP Ombudsman

          545 Grover Road

          Muskegon, MI  49442-9427

          U.S.A.

 or send a CompuServe message via CompuServe MAIL to ASP Ombudsman

 [70007,3536].


Note for Shareware Distributors

K.I.T.A.L. Software grants you, without charge, the right to reproduce and distribute

copies of the "SHAREWARE" version of FunctionMagic on the express conditions:

1.	NO fee other than a disk and handling charge (of up to $10 per disk) may be charged. The rights to receive any such financial or other benefits are exclusively reserved by K.I.T.A.L. Software.

2.	NO change will be made to this license agreement or the copyright notice.

3.	No change will be made to the installation and disk files, the diskette must be distributed as is, except an introduction file/s that can be added by shareware distributors.

4.	If you are not an ASP approved disk vendor, you can distribute this software ONLY with K.I.T.A.L.'s written approval. Please attach your catalog.

This package comes on one 5.25" 1.2M or 3.5" 1.44M floppy diskette.


Registration

To legally try and use FunctionMagic for more than 30 days you need to register it. When you register, we send you a letter confirming your registration. For complete information, see the VENDOR.TXT, REGISTER.TXT, INVOICE.TXT and the README.TXT files.


Installation

See the README.TXT file.


Starting the Main Program

Start Lotus 1-2-4 version 4.01 or 5.0 for Windows 3.1 and make the new directory the default directory. Use the User Setup or use the Lotus CLASSIC command sequence:

                / W G D D FUNCMAGC

and press the ENTER key.

Open one of your worksheets or open a new one and then open the FUNCMAGC.WK4 file into Lotus 1-2-3. Make your worksheet the current worksheet and press the Ctrl-Y key combination to start FunctionMagic. The standard Lotus menu will change into the following menu:

Now you can use the mouse to select and apply most of Lotus 1-2-3 functions. For example, when you click with the mouse on the Math menu option, the following menu appears:

When you press ENTER or click with mouse on the One argument trigonometric functions, the following dialog box appears:

In this dialog box with can see the following control items:

1.	The functions area, where you can select the functions by clicking with mouse on the function name.

2.	The edit box where you enter the argument for the function.

3.	The OK or Cancel buttons

4.	The Help button. When you click on the Help Button the Lotus 1-2-3 help about the selected function appears.

5.	The Formula and Value radio check buttons which allow you to choose to receive the results of the function as dynamic live formulas such as @SIN(X) or as fixed values.

Here is how the dialog box looks when we enter the 1.5 value in the edit box and we select the @SIN function.

When you click on the Help button, Lotus 1-2-3 displays the Help document for the @SIN function as follows:

The two other buttons need explanation:

6.	By default, the output button  shows the last known cell pointer location for the upper left cell of the output range. In this example it shows the $A:$A$1 cell address. When you click with the mouse on it, a dialog box appears and asks you for the output range.

Select a new range with the mouse, write the new range address or use the arrow keys to select it and select OK. The text on the output button will show the address of the new selected range.

7.	When you click on the clear button under the edit box, a dialog box appears and prompts you to select a range of arguments.

If for example, you select the A1..A7 area, the dialog box will look like the following:

When you select the OK button, the program calculate the @SIN function for all the values in the A1..A7 area. The results appear in the output range, the B1..B7 range, as it is shown in the next screen:

Note that if the range that contains the value arguments is rowwise oriented, the range of the results will be rowwise oriented too. For example, if you select the A1..E1 as the range of values and you select the upper left cell of the output range to be the A2 cell, the range containing the results is the A2..E2 range. The program creates the results in a range with the same orientation as the input range.


Using an Individual Function Without the Main Program

If you prefer, you can use all the functions individually without the main program. Just open the appropriate file and use the instructions. For example, if you want to perform a Student's t-test, open the TTEST.WK4 file and follow the instructions.

Note: All the function files are standard Lotus 1-2-3 macros. You start then as any Lotus

          1-2-3 macro, press ALT-F3, select the @@@XXX or the 0@@@XXX macro

          name and select OK.